"Sort (cost=459.19..459.19 rows=1 width=83) (actual time=117.026..117.217 rows=458 loops=1)" " Sort Key: to_char((coitem.coitem_scheddate)::timestamp with time zone, 'Month Dy DD YYYY'::text), cohead.cohead_number, coitem.coitem_linenumber" " -> Nested Loop Left Join (cost=0.00..459.18 rows=1 width=83) (actual time=0.186..112.660 rows=458 loops=1)" " -> Nested Loop (cost=0.00..191.54 rows=1 width=75) (actual time=0.125..18.115 rows=458 loops=1)" " -> Nested Loop (cost=0.00..191.22 rows=1 width=44) (actual time=0.114..13.976 rows=458 loops=1)" " -> Nested Loop (cost=0.00..182.94 rows=1 width=40) (actual time=0.105..10.142 rows=458 loops=1)" " -> Nested Loop (cost=0.00..182.53 rows=1 width=30) (actual time=0.094..5.974 rows=458 loops=1)" " -> Index Scan using coitem_status_key on coitem (cost=0.00..174.25 rows=1 width=30) (actual time=0.079..1.112 rows=458 loops=1)" " Index Cond: (coitem_status = 'O'::bpchar)" " Filter: ((coitem_scheddate >= '2008-01-01'::date) AND (coitem_scheddate <= '2008-12-31'::date))" " -> Index Scan using itemsite_pkey on itemsite (cost=0.00..8.27 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=458)" " Index Cond: (coitem.coitem_itemsite_id = itemsite.itemsite_id)" " -> Index Scan using item_pkey on item (cost=0.00..0.40 rows=1 width=18) (actual time=0.005..0.006 rows=1 loops=458)" " Index Cond: (itemsite.itemsite_item_id = item.item_id)" " -> Index Scan using cohead_pkey on cohead (cost=0.00..8.27 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=458)" " Index Cond: (cohead.cohead_id = coitem.coitem_cohead_id)" " -> Index Scan using cust_pkey on custinfo (cost=0.00..0.31 rows=1 width=39) (actual time=0.004..0.005 rows=1 loops=458)" " Index Cond: (cohead.cohead_cust_id = custinfo.cust_id)" " -> Index Scan using wo_pkey on wo (cost=0.00..8.27 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=458)" " Index Cond: (wo.wo_id = coitem.coitem_order_id)" " SubPlan" " -> Nested Loop (cost=63.90..131.53 rows=1 width=36) (actual time=0.067..0.137 rows=1 loops=419)" " Join Filter: (wrkcnt.wrkcnt_id = wooper.wooper_wrkcnt_id)" " InitPlan" " -> Aggregate (cost=63.89..63.90 rows=1 width=4) (actual time=0.024..0.025 rows=1 loops=419)" " -> Index Scan using wooper_wo_id_index on wooper (cost=0.00..63.89 rows=1 width=4) (actual time=0.020..0.021 rows=1 loops=419)" " Index Cond: (wooper_wo_id = $0)" " Filter: wooper_rncomplete" " -> Index Scan using wooper_wo_id_index on wooper (cost=0.00..63.94 rows=1 width=8) (actual time=0.044..0.045 rows=1 loops=419)" " Index Cond: (wooper_wo_id = $0)" " Filter: (wooper_seqnumber = $1)" " -> Seq Scan on wrkcnt (cost=0.00..2.75 rows=75 width=36) (actual time=0.003..0.041 rows=75 loops=419)" " -> Aggregate (cost=63.89..63.90 rows=1 width=4) (actual time=0.025..0.026 rows=1 loops=419)" " -> Index Scan using wooper_wo_id_index on wooper (cost=0.00..63.89 rows=1 width=4) (actual time=0.021..0.022 rows=1 loops=419)" " Index Cond: (wooper_wo_id = $0)" " Filter: wooper_rncomplete" " -> Aggregate (cost=63.89..63.90 rows=1 width=4) (actual time=0.028..0.029 rows=1 loops=458)" " -> Index Scan using wooper_wo_id_index on wooper (cost=0.00..63.89 rows=1 width=4) (actual time=0.023..0.024 rows=1 loops=458)" " Index Cond: (wooper_wo_id = $0)" " Filter: wooper_rncomplete" "Total runtime: 118.150 ms"